Used to constrain the considered lock granularities for an index 用于約束經(jīng)過(guò)考慮的索引鎖粒度。
You can choose to change the locking granularity for some operations 您可以選擇更改某些操作的鎖定粒度。
Lock granularity and hierarchies 鎖粒度和層次結(jié)構(gòu)
Index locking granularity 索引鎖定粒度
For more information about configuring the locking granularity for an index , see 有關(guān)為索引配置鎖定粒度的詳細(xì)信息,請(qǐng)參閱
Use caution , because changing locking granularity can have adverse effects on concurrency 請(qǐng)慎用此操作,因?yàn)楦逆i定粒度可能對(duì)并發(fā)性有負(fù)面影響。
The database engine can dynamically choose the level of lock granularity based on the optimizer s estimate of the number of rows a transact - sql statement will reference 數(shù)據(jù)庫(kù)引擎可以根據(jù)優(yōu)化器估計(jì)的transact - sql語(yǔ)句可能引用的行數(shù),動(dòng)態(tài)地選擇鎖粒度級(jí)別。